Query Optimization- An Experimental Approach for Distributed Environment

This paper strongly emphasizes the approach for query optimization which is a frame work model for distributed computing environment systems. We have two popular methods for query optimization. One which is traditional which follows the stages like query planning, deployment and adaptation. The second one which is our main experimental approach which follows the stages like query planning and deployment together as a single stage followed by adaptation [1]. The approach of integration of planning and deployment while writing for distributed queries which involve many sub-queries in distributed data stream systems and applications. This method makes use of hierarchical network partitions which provides operator levelreuse which utilizing network characteristics to maintain an appropriate search space during query planning and deployment. The approach has been practically experimented and proved its efficiency over the traditional methods. Key Words-Distributed Data Bases, Distributed Systems, Optimization, Communication networks, query processing and deployment